import pandas as pd
pd.set_option('display.unicode.east_asian_width',True)
pd.set_option('expand_frame_repr',False)
df=pd.read_excel("营销和产品销量表.xlsx")
print(df.corr())


import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel("学生各学期成绩表.xlsx")
x=df['序号']
y=df['语文']
plt.plot(x,y)
plt.figure('学生成绩',(5,4),facecolor='yellow')
plt.plot(x,y)
plt.show()